package bank.model.properties;

public interface DBTables {
	public static final String DB_NAME = "bankserver";
	public static final String TBL_ACCOUNTS = DB_NAME + ".ACCOUNTS";
	public static final String TBL_CLIENTS = DB_NAME + ".CLIENTS";
	public static final String TBL_DEPARTMENTS = DB_NAME + ".DEPARTMENTS";
	public static final String TBL_PAYMENTS = DB_NAME + ".PAYMENTS";
	public static final String TBL_EMPLOYEES = DB_NAME + ".EMPLOYEES";
	public static final String TBL_LOGIN = DB_NAME + ".LOGIN";
	public static final String TBL_GROUPS = DB_NAME + ".GROUPS";
	
	/**
	 * ACCOUNTS TABLE COLUMNS:
	 */
	public static final String ACCOUNT_ID = "ID";	
	public static final String ACCOUNT_AMOUNT = "AMOUNT";		
	public static final String ACCOUNT_CLIENT_ID = "CLIENT_ID";
	
	/**
	 * ACCOUNTS TABLE COLUMNS:
	 */
	public static final String CLIENT_ID = "ID";	
	public static final String CLIENT_FIRSTNAME = "FIRSTNAME";		
	public static final String CLIENT_LASTNAME = "LASTNAME";
	public static final String CLIENT_SUBNAME = "SUBNAME";
	
}
